ERROR CODE
От | Ray Alba |
---|---|
Тема | ERROR CODE |
Дата | |
Msg-id | v03007802b53081fc313a@[208.37.244.165] обсуждение исходный текст |
Ответы |
Re: ERROR CODE
|
Список | pgsql-general |
I am creating a new table called patienttype with categories - infant,pediatric, adult in the doctors table for some reason it allows me to create a sequence but, when I create a table that requires that sequence, I get the following. create table patienttype ( id INT DEFAULT nextval ('category_seq'), parent id INT DEFAULT '0', type varchar(50)); Here is the error? What is that all about? ERROR: Unable to locate type name 'id' in catalog Thanks, Ray --------------------------------- * *** * * Ray Alba/ dotsperinch * * 74 Varick | 55 W 92nd St. * * 212.966.4979 | 212.864.6456 * * Fax.966.3866 | 212.864.4489 * * ralba@dotsperinch.com * * http://www.dotsperinch.com * * http://www.dotsperinch.com * ---------------------------------
В списке pgsql-general по дате отправления: